An educational tool for regression models with dummy variables using Excel VBA
نویسندگان
چکیده
منابع مشابه
Programming Excel with VBA and .NET - solve real-world problems with Excel
by Jeff Webb : Programming Excel with VBA and .NET: Solve Real-World Problems with Excel ISBN : #0596007663 | Date : 2006-05-05 Description : PDF-716bf | Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining exist...
متن کاملHow Robust Is Linear Regression with Dummy Variables
Researchers in education and the social sciences make extensive use of linear regression models in which the dependent variable is continuous-valued while the explanatory variables are a combination of continuous-valued regressors and dummy variables. The dummies partition the sample into groups, some of which may contain only a few observations. Such groups may easily include enough outliers t...
متن کاملAssessing Excel VBA Suitability for Monte Carlo Simulation
Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions,...
متن کاملDummy Endogenous Variables in Nonseparable Models
This paper considers the nonparametric identification and estimation of the average effect of a dummy endogenous variable in nonseparable models. The analysis includes the case of a dummy endogenous variable in a discrete choice model as a special case. This paper establishes conditions under which it is possible to identify and consistently estimate the average effect of the dummy endogenous v...
متن کاملRegression Models with Ordinal Variables*
Most discussions of ordinal variables in the sociological literature debate the suitability of linear regression and structural equation methods when some variables are ordinal. Largely ignored in these discussions are methods for ordinal variables that are natural extensions of probit and logit models for dichotomous variables. If ordinal variables are discrete realizations of unmeasured conti...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Journal of the Korean Data and Information Science Society
سال: 2013
ISSN: 1598-9402
DOI: 10.7465/jkdi.2013.24.3.593